Configuring: Rate of Change
The rate of change (ROC) is calculated as the difference between two data values, divided by the period over which the change occurred. This period can be based on the selected timestamp field or the row number.
Worked example: Rate of change
Steps to configure
-
Configure period: Set which parameter you wish to use to calculate the ROC. This can either be the row number or the field timestamp.
-
Fields selection: Select the fields for which the ROC will be calculated.
-
Rate of change fields: Rename the ROC fields that will be created, and specify custom periods for each field if required.
-
Execute: The rate of change will be calculated, and the fields containing the ROC values will be added to the database.
Step 1: Configure period
Calculation type:
-
Row based: Calculate the ROC using a change in row numbers. If this option is selected, you will need to define the number of rows over which the change will be calculated.
-
Timestamp based: Calculate the ROC using a change in timestamps. If this option is selected, you will need to define the number of seconds over which the change will be calculated. One of the timestamp fields within the dataset needs to be selected.
-
Default: Row based. The first timestamp field is listed in the drop down box, if the timestamp based calculation type is selected.
-
Minimum configuration: at least one calculation type must be selected.
Period:
-
Define either the number of rows or the number of seconds as the period to be used in calculating the ROC.
-
For using rows as a calculation type, the period defined must be a positive integer.
-
For using timestamps as a calculation type, the period defined must be a positive number.
-
Default: 0
-
Minimum configuration: A number must be entered into this field to continue with configuration.
Step 2: Field selection
Select the fields for which the rate of change will be calculated.
-
All fields that are possible options are listed in the [Selected] window. Toggle fields between selected and available using the [<] and [>] arrows.
-
Selected fields will be of type double or integer.
-
Default: the maximum number of fields will be selected. This is determined by the limitations of the dataset.
-
Minimum configuration: At least one field must be selected.
Step 3: Rate of change field selection
New fields with calculated ROC values will be created.
-
Define fields names for each new ROC fields, and specify a custom period for each of these fields, if required.
-
Only valid field names are accepted.
-
Default: The field name will be prefixed with ROC_
-
Period:
-
-
Rows: If using row number was initially defined in Step1, then the period as a number of rows will be requested here. The period defined must be a positive integer.
-
Timestamp: If using timestamp values was initially defined in Step1, then the period as a number of seconds will be requested here. The period defined must be a positive number.
-
Step 4: Execute
The rate of change will be calculated, and the newly created rows will appear in the dataset.
Related topics:
-
Overview of categories and their effects on data sets
-
Overview of icons
-
Technical comparison of operations